Excel 2019 - Modifying and Formatting Worksheets, Cell and Table Styles and Applying Themes
      This course is part of the MOS exam 77-727 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam. In this course you will learn about Modifying Worksheets. You will also learn about Cell and Table Styles, as well as Formatting Worksheets and Applying Themes.      
      Modifying Worksheets      
      Upon successful completion you will be able to:

1. Hide and Unhide Columns and Rows;
2. Hide and Unhide Worksheets;
3. Group Worksheets;
4. Ungroup Worksheets;
5. Insert Multiple Rows and Columns;
6. Move Rows and Columns;
7. Open New Windows;
8. Arrange Multiple Windows;
9. Hide and Unhide Windows.

      
      Cell and Table Styles      
      Upon successful completion you will be able to:

1. Apply and Remove Cell Styles;
2. Create Custom Cell Styles;
3. Apply Custom Cell Styles;
4. Modify Cell Styles;
5. Apply Table Styles;
6. Use the Total Row Option;
7. Name Tables;
8. Insert Columns and Rows;
9. Use Quick Analysis Tools.		      
      Formatting Worksheets      
      Upon successful completion you will be able to:

1. Apply and Remove Backgrounds;
2. Add Header and Footers;
3. Add Washout Images;
4. Resize Images;
5. Change Column Widths;
6. Change Row Heights;
7. Transpose Data.		      
      Applying Themes      
      Upon successful completion you will be able to:

1. Apply Themes;
2. Modify Themes;
3. Create Custom Themes;
4. Apply Effects;
5. Save Custom Themes;
6. Change the Default Theme.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Modifying and Formatting Worksheets, Cell and Table Styles and Applying Themes :
Program Training Courses - Microsoft Excel 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters